Documentation

Enable Remote Access to phpMyAdmin

XAMPP includes phpMyAdmin, an open-source, browser-based tool for managing MySQL/MariaDB database servers. By default, for security reasons, phpMyAdmin is configured to only accept connections from the host on which XAMPP is installed. Attempting to access phpMyAdmin from any other host will produce the error below:

image1

To enable remote access to phpMyAdmin from other hosts, follow these steps:

  1. Launch the stack manager by double-clicking the XAMPP icon in the mounted disk image.

  2. Ensure that Apache and MySQL services are running in the "Services" tab of the stack manager (or start them as needed).

  3. Open a new terminal from the "General" tab of the stack manager.

  4. Edit the /opt/lampp/etc/extra/httpd-xampp.conf file.

  5. Within this file, find the block below:

    <Directory "/opt/lampp/phpmyadmin">
  AllowOverride AuthConfig
  Require local
  ...

    Update this block and replace Require local with Require all granted, so that it looks like this:

    <Directory "/opt/lampp/phpmyadmin">
  AllowOverride AuthConfig
  Require all granted
  ...

  6. Save the file and restart the Apache service using the stack manager.

You should now be able to access phpMyAdmin from other hosts.